package com.itheima.bos.web.action.base;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Join;
import javax.persistence.criteria.JoinType;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;

import org.apache.commons.lang3.StringUtils;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.ParentPackage;
import org.apache.struts2.convention.annotation.Result;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.domain.Specification;
import org.springframework.stereotype.Controller;

import com.itheima.bos.domain.base.Courier;
import com.itheima.bos.domain.base.Standard;
import com.itheima.bos.service.base.CourierService;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
@ParentPackage("json-default")
@Namespace("/")
@Controller
@Scope("prototype")
public class CourierAction extends ActionSupport implements 
      ModelDriven<Courier>{
	
	//模型驱动
	private Courier courier=new Courier();
	
	@Override
	public Courier getModel() {
		return courier;
	}
	
	//注入service
	@Autowired
	private CourierService courierService;
	//添加快递员方法
	@Action(value="courier_save",
			results={@Result(name="success",
			location="./pages/base/courier.html",type="redirect")})
	public String save(){
		courierService.save(courier);
		return SUCCESS;
	}
	
	//属性驱动接受客户端分页参数
	private int page;
	private int rows;

	public void setPage(int page) {
		this.page = page;
	}
	public void setRows(int rows) {
		this.rows = rows;
	}
	
	//分页查询方法
	@Action(value="courier_pageQuery",results={@Result(name="success",type="json")})
	public String pageQuery(){
		//封装Pageable对象
		Pageable pageable=new PageRequest(page-1, rows);
		//封装条件查询对象Specification
		Specification<Courier> specification=new Specification<Courier>() {

			@Override
			// Root 用于获取属性字段，CriteriaQuery可以用于简单条件查询，CriteriaBuilder 用于构造复杂条件查询
			public Predicate toPredicate(Root<Courier> root,
					CriteriaQuery<?> query, CriteriaBuilder cb) {
				//创建list集合存取单表查询条件
				List<Predicate> list=new ArrayList<Predicate>();
				//简单单表查询
				//按工号查询
				if(StringUtils.isNotBlank(courier.getCourierNum())){
					Predicate p1=cb.equal(
							root.get("courierNum").as(String.class),
							 courier.getCourierNum());
					list.add(p1);
				}
				//按所属单位查询(使用模糊查询)
				if(StringUtils.isNotBlank(courier.getCompany())){
					Predicate p2=cb.like(
							     root.get("company").as(String.class),
							     "%"+courier.getCompany()+"%");
					list.add(p2);
				}
				//按照类型查询
				if(StringUtils.isNotBlank(courier.getType())){
					Predicate p3=cb.equal(
								 root.get("type").as(String.class),
									courier.getType());
					list.add(p3);	
				}
				//多表查询(查询当前对象 关联 对象 对应数据表)
				//使用Courier(root),关联Standara
				Join<Courier, Standard> standaraRoot = root.join("standard",JoinType.INNER);
				if(courier.getStandard()!=null
						&& StringUtils.isNotBlank(courier.getStandard().getName())){
					//进行收派标准 名称 模糊查询
					//standard.name like %?%
					Predicate p4=cb.like(standaraRoot.get("name").as(String.class), 
							      "%"+courier.getStandard().getName()+"%");
					list.add(p4);
				}
				
				return cb.and(list.toArray(new Predicate[0]));
			}
		};
		
		
		//调用业务层,返回Page
		Page<Courier> pageData = courierService.findPageData(specification,pageable);
		//将返回page对象转换datagrid需要格式
		Map<String, Object> result=new HashMap<String, Object>();
		result.put("total", pageData.getTotalElements());
		result.put("rows", pageData.getContent());
		//将结果对象 压入值栈顶部转换为json格式
		ActionContext.getContext().getValueStack().push(result);
		System.out.println("你好啊 ----"+result);
		
		return SUCCESS;
	}
	
	//属性驱动
	private String ids;

	public void setIds(String ids) {
		this.ids = ids;
	}
	
	//作废快递员
	@Action(value="courier_delBatch",
			results={@Result(name="success",
			location="./pages/base/courier.html",type="redirect")})
	public String delBathch(){
		//按,分隔ids
		String[] idArray = ids.split(",");
		//调用业务层,批量作废
		courierService.delBatch(idArray);
		
		return SUCCESS;
	}
	
	
}
